const daoCommon = require('../../util/daoCommon');

const dao = {
    handleGetCategory: () => {
        let sql;
        sql = "select category_title,category_content from category where is_delete='0'";
        return daoCommon.selectCommon(sql);
    },
    handleGetImgUrl: () => {
        let sql;
        sql = "select picture_url from picture where picture_type='1'";
        return daoCommon.selectCommon(sql);
    },
    handleGetCase: () => {
        let sql;
        sql = "select case_id,case_name,case_mainImg from cases where is_recommend='1' and is_delete='0' and is_enabled='1'";
        return daoCommon.selectCommon(sql);
    }
};
module.exports = dao;